Skip to main Content

Data Warehousing with Google BigQuery: Storage Design, Query Optimization, and Administration

In this course, you learn about the internals of BigQuery and best practices for designing, optimizing, and administering your data warehouse. Through a combination of lectures, demos, and labs, you learn about BigQuery architecture and how to design optimal storage and schemas for data ingestion and changes. Next, you learn techniques to improve read performance, optimize queries, manage workloads, and use logging and monitoring tools. You also learn about the different pricing models. Finally, you learn various methods to secure data, automate workloads, and build machine learning models with BigQuery ML.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Delivery Format

  • Company Event

    Event at company

  • Virtual Learning

    Learning that is virtual

2 courses found

    • Delivery Format: Virtual Learning
    • Date 14-16 December, 2026 | 9:00 AM to 5:00 PM
    • Location: Virtual (Eastern Standard Time)
    • Language: English

    $2,700.00

    • Delivery Format: Virtual Learning
    • Date 14-16 December, 2026 | 9:00 AM to 5:00 PM
    • Location: Virtual (Eastern Standard Time)
    • Language: English
    Request Space

Request a date or location for this course

Dates in Other Countries

We Care About Your Privacy

We are using cookies to give you the best experience on our site. Cookies are files stored in your browser and are used by most websites to help personalise your web experience. By continuing to use our website without changing the settings, you are agreeing to our use of cookies.

About your Privacy

We process your data for purposes such as delivering content or advertisements and measuring the delivery of such content or advertisements to extract insights about our website. We may share this information with our partners. Cookies set by Global Knowledge are labelled “first party”; you may exercise your preferences in relation to first party cookies by toggling the switch for each first party cookie category below. The remaining cookies are third party cookies; you may exercise your preferences in relation to each purpose by toggling the relevant switch below or by vendor by clicking “List of IAB Vendors.” These choices will be signaled globally to other websites participating in the Transparency and Consent Framework.
Privacy Statement

Necessary Cookies

These are cookies that are required for the Global Knowledge website to function and cannot be switched off in our systems. They include, for example, cookies that enable you to use a shopping cart or log into the booking area of our website.

Analytics Cookies

Analytics cookies are an optional but important part of our website's functionality. They help us to understand how you interact with our site by collecting and reporting information anonymously. The data collected by analytics cookies is used to improve the website's performance and enhance the user experience. It is important to note that these cookies do not collect any personal information that can be used to identify you.

Preferences Cookies

The preference cookies are used to track visitors across websites with the intention to display ads that are relevant and engaging to your interests.

Performance Cookies

These cookies allow us to recognise and count the number of visitors to our website, traffic sources and to see how website visitors move around the website when they are using it. This helps us to improve the way the website works and improve your website experience. All information these cookies collect is aggregated and therefore anonymous.

Marketing Cookies

Marketing cookies help us understand how visitors interact with our website. Should you grant consent for marketing purposes, this information will be used for general marketing analysis — allowing us to measure the effectiveness of our campaigns, better understand our audience, and improve the content and offers we provide. These cookies are not essential to the website’s function, and you may withdraw or amend your consent at any time through our cookie settings.

Cookie Control toggle icon